﻿using NetWing.Common.Data.SqlServer;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace NetWing.BPM.Admin.JydModleOrder
{
    public partial class print_order_sn : System.Web.UI.Page
    {
        protected string comname;
        protected string salesman;
        protected string order_sn;
        protected string kdy;
        protected string manager;
        protected string unit_man;
        public DataTable dt = null;
        public DataTable dat = null;
        protected string gg;
        protected string jh_time;
        protected string sl;
        protected string unito;
        protected string ordername;
        protected void Page_Load(object sender, EventArgs e)
        {
            string order = Request["order_sn"];
            dat = SqlEasy.ExecuteDataTable("select * from sparepartszhu where order_sn='"+ order + "'");
            dt = SqlEasy.ExecuteDataTable("select * from spareparts where order_sn='"+ order + "'");
            foreach(DataRow dataRow in dat.Rows)
            {
                comname = dataRow["comname"].ToString();
                salesman = dataRow["salesman"].ToString();
                order_sn = dataRow["order_sn"].ToString();
                ordername = dataRow["ordername"].ToString();
                kdy = dataRow["kdy"].ToString();
                if(int.Parse(dataRow["manager"].ToString()) == 1)
                {
                    manager = "已处理";
                }
                else
                {
                    manager = "未处理";
                }
                gg = dataRow["gg"].ToString();

                jh_time = dataRow["jh_time"].ToString();



                sl = dataRow["ordernuber"].ToString();
                unito = dataRow["unit_man"].ToString();
            }
        }
    }
}